Workshop
These quiz questions are designed to test your knowledge of the material
covered in this chapter. The answers to the quiz questions can be found in
Appendix A, "Answers to Quizzes."
Quiz
Which method of the SqlTransaction object finalizes a
transaction? How is this done in T-SQL? In ADO.NET, a database transaction is started by using which
object?
Exercise
Try to implement a simple financial transaction example, like the one
mentioned in the introduction of this hour. Create two database tables, one for
bank A and one for bank B. Then create a procedure that copies the checking and
savings balance from one bank to another for a given AccountID. Make sure, of
course, to use a transaction to perform the transfer.
| 
View Cart
